package com.cul;

import java.util.List;

public class SqlFromExcelParam {
    /**
     * 文件路径
     */
    private String excelFilepath;

    /**
     * 文件路径
     */
    private String sqlFilepath;

    /**
     * sheet页名字
     */
    private String sheetName;

    /**
     * 所需读取列名
     */
    private List<String> titleNames;

    /**
     * 列名所在行号
     */
    private Integer titleRowNO;

    /**
     * 数据读取开始行
     */
    private Integer startRow;


    /**
     * 数据读取结束行
     */
    private Integer endRow;

    /**
     * 修改表名
     * @return
     */
    private String tableName;

    public String getTableName() {
        return tableName;
    }

    public SqlFromExcelParam setTableName(String tableName) {
        this.tableName = tableName;
        return this;
    }

    public String getExcelFilepath() {
        return excelFilepath;
    }

    public SqlFromExcelParam setExcelFilepath(String excelFilepath) {
        this.excelFilepath = excelFilepath;
        return this;
    }

    public String getSqlFilepath() {
        return sqlFilepath;
    }

    public SqlFromExcelParam setSqlFilepath(String sqlFilepath) {
        this.sqlFilepath = sqlFilepath;
        return this;
    }

    public String getSheetName() {
        return sheetName;
    }

    public SqlFromExcelParam setSheetName(String sheetName) {
        this.sheetName = sheetName;
        return this;
    }

    public List<String> getTitleNames() {
        return titleNames;
    }

    public SqlFromExcelParam setTitleNames(List<String> titleNames) {
        this.titleNames = titleNames;
        return this;
    }

    public Integer getTitleRowNO() {
        return titleRowNO;
    }

    public SqlFromExcelParam setTitleRowNO(Integer titleRowNO) {
        this.titleRowNO = titleRowNO;
        return this;
    }

    public Integer getStartRow() {
        return startRow;
    }

    public SqlFromExcelParam setStartRow(Integer startRow) {
        this.startRow = startRow;
        return this;
    }

    public Integer getEndRow() {
        return endRow;
    }

    public SqlFromExcelParam setEndRow(Integer endRow) {
        this.endRow = endRow;
        return this;
    }

    @Override
    public String toString() {
        return "SqlFromExcelParam{" +
                "excelFilepath='" + excelFilepath + '\'' +
                ", sqlFilepath='" + sqlFilepath + '\'' +
                ", sheetName='" + sheetName + '\'' +
                ", titleNames=" + titleNames +
                ", titleRowNO=" + titleRowNO +
                ", startRow=" + startRow +
                ", endRow=" + endRow +
                '}';
    }
}
